<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title>学生管理系统</title>
  <link rel="stylesheet" href="styles.css">
</head>
<body>
  <div class="container">
    <nav class="sidebar">
      <h2>功能菜单</h2>
      <button onclick="showImport()">导入数据</button>
      <button onclick="showQuery()">查询数据</button>
    </nav>
    
    <main class="content">
      <div id="import-section" class="hidden">
        <h3>数据导入</h3>
        <input type="file" id="file-input" accept=".txt,.xlsx">
        <div id="file-preview"></div>
        <button onclick="uploadFile()">导入数据库</button>
      </div>

      <div id="query-section" class="hidden">
        <h3>学生查询</h3>
        <input type="text" id="search-input" placeholder="输入姓名或班级">
        <button onclick="searchStudents()">搜索</button>
        <div id="results"></div>
      </div>
    </main>
  </div>

  <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
  <script src="sql.js"></script>
  <script src="app.js"></script>
</body>
</html>